www.gusucode.com > DB-Libray 操作SQLServer编程的VC++ 一例-源码程序 > DB-Libray 操作SQLServer编程的VC++ 一例-源码程序\code\PhManage\PhysicM.cpp
// PhysicM.cpp : Defines the class behaviors for the application. // Download by http://www.NewXing.com #include "stdafx.h" #include "PhysicM.h" #ifdef _DEBUG #define new DEBUG_NEW #undef THIS_FILE static char THIS_FILE[] = __FILE__; #endif ///////////////////////////////////////////////////////////////////////////// // CPhysicMApp BEGIN_MESSAGE_MAP(CPhysicMApp, CWinApp) //{{AFX_MSG_MAP(CPhysicMApp) ON_COMMAND(ID_APP_ABOUT, OnAppAbout) // NOTE - the ClassWizard will add and remove mapping macros here. // DO NOT EDIT what you see in these blocks of generated code! //}}AFX_MSG_MAP // Standard file based document commands ON_COMMAND(ID_FILE_NEW, CWinApp::OnFileNew) ON_COMMAND(ID_FILE_OPEN, CWinApp::OnFileOpen) // Standard print setup command ON_COMMAND(ID_FILE_PRINT_SETUP, CWinApp::OnFilePrintSetup) END_MESSAGE_MAP() ///////////////////////////////////////////////////////////////////////////// // CPhysicMApp construction CPhysicMApp::CPhysicMApp() { pMainFrm=NULL; // TODO: add construction code here, // Place all significant initialization in InitInstance } ///////////////////////////////////////////////////////////////////////////// // The one and only CPhysicMApp object CPhysicMApp theApp; ///////////////////////////////////////////////////////////////////////////// // CPhysicMApp initialization BOOL CPhysicMApp::InitInstance() { if(!AfxInitRichEdit()) return FALSE; try{ if(!DBSession.Connect("sa","9605001","127.0.0.1")) return FALSE; #ifdef _DEBUG DBSession.SetDataBase("Demo"); #else DBSession.SetDataBase("physic"); #endif } catch(DBErr *dberr) { char *err; int errcode; dberr->GetLastErr(errcode,&err); AfxMessageBox(err); } AfxEnableControlContainer(); // Standard initialization // If you are not using these features and wish to reduce the size // of your final executable, you should remove from the following // the specific initialization routines you do not need. #ifdef _AFXDLL Enable3dControls(); // Call this when using MFC in a shared DLL #else Enable3dControlsStatic(); // Call this when linking to MFC statically #endif // Change the registry key under which our settings are stored. // TODO: You should modify this string to be something appropriate // such as the name of your company or organization. SetRegistryKey(_T("Local AppWizard-Generated Applications")); LoadStdProfileSettings(); // Load standard INI file options (including MRU) // create main MDI Frame window CMainFrame* pMainFrame = new CMainFrame; if (!pMainFrame->LoadFrame(IDR_MAINFRAME)) return FALSE; m_pMainWnd = pMainFrame; pMainFrm=pMainFrame; // Parse command line for standard shell commands, DDE, file open CCommandLineInfo cmdInfo; ParseCommandLine(cmdInfo); // Dispatch commands specified on the command line if (!ProcessShellCommand(cmdInfo)) return FALSE; // The main window has been initialized, so show and update it. //pMainFrame->ShowWindow(m_nCmdShow); #ifdef _DEBUG pMainFrame->SetWindowText("药品管理测试版 V1.30"); #else pMainFrame->SetWindowText("药品管理系统 V1.40"); #endif pMainFrame->ShowWindow(SW_MAXIMIZE); pMainFrame->UpdateWindow(); return TRUE; } ///////////////////////////////////////////////////////////////////////////// // CAboutDlg dialog used for App About class CAboutDlg : public CDialog { public: CAboutDlg(); // Dialog Data //{{AFX_DATA(CAboutDlg) enum { IDD = IDD_ABOUTBOX }; //}}AFX_DATA // ClassWizard generated virtual function overrides //{{AFX_VIRTUAL(CAboutDlg) protected: virtual void DoDataExchange(CDataExchange* pDX); // DDX/DDV support //}}AFX_VIRTUAL // Implementation protected: //{{AFX_MSG(CAboutDlg) // No message handlers //}}AFX_MSG DECLARE_MESSAGE_MAP() }; CAboutDlg::CAboutDlg() : CDialog(CAboutDlg::IDD) { //{{AFX_DATA_INIT(CAboutDlg) //}}AFX_DATA_INIT } void CAboutDlg::DoDataExchange(CDataExchange* pDX) { CDialog::DoDataExchange(pDX); //{{AFX_DATA_MAP(CAboutDlg) //}}AFX_DATA_MAP } BEGIN_MESSAGE_MAP(CAboutDlg, CDialog) //{{AFX_MSG_MAP(CAboutDlg) // No message handlers //}}AFX_MSG_MAP END_MESSAGE_MAP() // App command to run the dialog void CPhysicMApp::OnAppAbout() { CAboutDlg aboutDlg; aboutDlg.DoModal(); } ///////////////////////////////////////////////////////////////////////////// // CPhysicMApp message handlers int CPhysicMApp::ExitInstance() { // TODO: Add your specialized code here and/or call the base class DBSession.DestroyDBSession(); return CWinApp::ExitInstance(); } void CPhysicMApp::Delete(CString TableName,CString TableColName,CListCtrl *pl,int col) { if(pl->GetSelectedCount()<=0){ pMainFrm->AddLog("请选择相应记录后再执行删除操作"); return; } CString tmp; int i=pl->GetSelectionMark(); tmp=pl->GetItemText(i,col); if(AfxMessageBox("确实要删除ID="+tmp+"的记录吗?",MB_YESNO | MB_ICONQUESTION | MB_DEFBUTTON2 )==IDNO) return; DBLibrary DB(DBSession); try{ DB.ExecSQL("delete from %s where %s=%s",TableName,TableColName,tmp); pMainFrm->AddLog("删除%s表中%s=%s的记录",TableName,TableColName,tmp); pl->DeleteItem(i); char index[3]; for(int i=0;i<pl->GetItemCount();i++) { sprintf(index,"%03d",i+1); pl->SetItemText(i,0,(LPCTSTR)index); // m_ProviderList.Update(i); } //m_ProviderList.Update( }catch(DBErr &err) { char *str; int ecode; err.GetLastErr(ecode,&str); pMainFrm->AddErr(str,ecode); }catch(...) { pMainFrm->AddErr("unknow error!",-1); } }